How to publish your Database on WWW.

It is really easy to publish your existing databases on World Wide Web using FolkWeb Server built-in Database Connectivity. If you are familiar with creating HTML 2.0 forms you will not find hard to understand the following steps:

If you have not installed ODBC 2.0 software and drivers FolkWeb Setup will do it for you. FolkWeb Setup will register a sample MS Access Database ilar.mdb with ODBC administrator under IlarDtb name. You can find this data source when you double click on ODBC icon in Control Panel.

You should use POST method for publishing databases. In Action for HTML form you should enter the name under which you registered your database as Data Source and append it with dot and "dbc" extension. For Instance you have database file my.mdb and you registered it as MyDb. So in Action you should enter MyDb.dbc.

All fields you wish to publish you should prepend with table names and dots. For Instance you have two tables: "MailingList" and "SalaryList". First table contains three fields: "firstname", "lastname" and "address". Second table contains two fields: "lastname" and "salary". You should title your INPUT NAMEs in HTML form as they appear in the tables.

<FORM METHOD="POST" ACTION="MyDb.dbc">

First Name: <INPUT NAME="MailingList.firstname" VALUE="" >

Last Name: <INPUT NAME="MailingList.lastname" VALUE="" >

Address: <INPUT NAME="MailingList.address" VALUE="" >

Salary: <INPUT NAME="SalaryList.salary" VALUE="" >

</FORM>

Now you are all set.

Click below to send your questions, comments and suggestions:
<support@ilar.com>

Back to Folkweb Server Page